
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW [dbo].[TMPROV_FINA] AS             
SELECT T1.[CO_PROV], T1.[CO_EMPR], T1.[NO_CORT_PROV], T1.[TI_PROV], T2.[DE_TIPO_PROV], T1.[CO_CATE], T1.[CO_CLNT],   
T1.[NU_RUCS_PROV], T1.[TI_CLAS_PROV], T1.[DE_RAZO_SOCI], T1.[NO_REPR_LEGA], T1.[NO_GERE_GRAL], T1.[NO_REPR_VTAS],   
T1.[NU_LICE_PROV], T1.[NU_EMPL], T1.[NU_REGI_PUBL], T1.[AP_PATE_PROV], T1.[AP_MATE_PROV], T1.[NO_PROV_NATU],   
T1.[NO_PROV_0002], T1.[TI_DOCU_IDEN], T1.[NU_DOCU_IDEN], T1.[DE_PROF], T1.[DE_MAIL], T1.[DE_EMPR_VERI], T1.[NO_VERI],   
T1.[FE_VERI], T1.[OB_VERI], T1.[FE_INGR], T1.[TI_SITU], T1.[ST_USOS_LOGI], T1.[ST_RETE], T1.[ST_BCON], T1.[ST_PERC],  
T1.[CO_DOCU_SUNA], T1.[NU_DOCU_SUNA], T1.[TI_PERS_SUNA],T1.[NU_RETE_SUNA], T1.[ST_APRO_EVAL], T1.[CO_COND_PAGO],   
T1.[ST_EVAL], T1.[CO_MONE_FACT], T1.[NU_REGI_COME], T1.[NU_REGI_MUNI], T1.[NU_REGI_VENT], T1.[NU_REGI_MERC], T1.[ST_SUJE_DETR], T1.[ST_DCTO]  
FROM [OFILOGI].[dbo].[TMPROV] T1, [OFILOGI].[dbo].[TTTIPO_PROV] T2            
WHERE T1.TI_PROV = T2.TI_PROV

GO
